CREATE TABLE [dbo].[WorkflowQueue]
(
[WorkFlowQueueKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_WorkflowQueue_WorkFlowQueueKey] DEFAULT (newid()),
[WorkItems] [image] NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_WorkflowQueue_Description] DEFAULT (''),
[TaskItemKey] [uniqueidentifier] NULL,
[SelectionKey] [uniqueidentifier] NULL,
[WorkFlowQueueItemStatusCode] [int] NOT NULL CONSTRAINT [DF_WorkflowQueue_WorkFlowQueueItemStatusCode] DEFAULT ((0)),
[Stage] [int] NULL CONSTRAINT [DF_WorkflowQueue_Stage] DEFAULT ((0)),
[DateExecuted] [datetime] NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL,
[TaskItemAccessKey] [uniqueidentifier] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[WorkflowQueue] ADD CONSTRAINT [PK_WorkflowQueue] PRIMARY KEY CLUSTERED ([WorkFlowQueueKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowQueue_CreatedByUserKey] ON [dbo].[WorkflowQueue] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowQueue_TaskItemAccessKey] ON [dbo].[WorkflowQueue] ([TaskItemAccessKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowQueue_TaskItemKey] ON [dbo].[WorkflowQueue] ([TaskItemKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowQueue_UpdatedByUserKey] ON [dbo].[WorkflowQueue] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WorkflowQueue] ADD CONSTRAINT [FK_WorkflowQueue_AccessMain] FOREIGN KEY ([TaskItemAccessKey]) REFERENCES [dbo].[AccessMain] ([AccessKey])
GO
ALTER TABLE [dbo].[WorkflowQueue] ADD CONSTRAINT [FK_WorkflowQueue_TaskItem] FOREIGN KEY ([TaskItemKey]) REFERENCES [dbo].[TaskItem] ([TaskItemKey])
GO
ALTER TABLE [dbo].[WorkflowQueue] ADD CONSTRAINT [FK_WorkflowQueue_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[WorkflowQueue] ADD CONSTRAINT [FK_WorkflowQueue_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO